I have a section which uses a counter for overflow (rather than @GETRECSUSED) and am using the MoveNum rule with a format mask of Z. I expect to see $0.00 for any record that contains a zero but I am seeing $0.00 for all fields even when there is only one record that contains a blank (not a zero). Here is an example:
Schedule of Riders Rider Benefit Monthly Cost
-------------------------------------------------------------
ESTATE PROTECTION RIDER $75,000,000.00 $0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Use the Z and E flags in the format mask.
The Z flag gets zero (0) output while input data is zero (0). The E flag stops a calculation if the search condition is false. And if a record was found but the mapped data was blank, it returns a null output buffer. So this solves the output zero (0) with blank input data problem, too. See the Rules Reference for more information about this rule.
© Copyright 2016, Oracle and/or its affiliates. All rights reserved. Legal notices.